{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["README"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[46,3,46,5],[45,1,45,2],[46,1,46,2],[31,2,31,5],[32,2,32,5],[33,2,33,5],[34,2,34,5],[37,3,37,5],[38,3,38,5],[39,3,39,5],[40,3,40,5],[42,3,42,5],[41,3,41,5],[43,3,43,5],[44,3,44,5],[45,3,45,5],[40,1,40,2],[42,1,42,2],[41,1,41,2],[43,1,43,2],[44,1,44,2],[30,1,30,5],[36,1,36,5],[37,1,37,2],[38,1,38,2],[39,1,39,2],[16,7,19,13],[2,1,3,5],[16,1,17,1],[20,1,21,1],[24,1,25,1],[8,1,11,5],[20,3,23,3],[16,3,17,3],[16,5,17,5],[20,5,23,5],[24,3,25,3],[24,5,25,5]]}
[]
[null,"Drug Monitoring",null,null,null,null,null,"NOTE:"]
[null,"This report is designed to show (in one list) prescribed medication that has not had recent test results performed in a given period of time",null,null,null,null,null,"This report will only work if Vision is on DLM485 or above."]
[null,null,null,null,null,null,null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[]
[null,"START DATE",null,null,null,null,null,"Excel 2007 - Please enable both Macros... and Data Connections"]
[null,"2017-07-13",null,null,null,null,null,"Excel 2003 - If macros are disabled you will need to enable them via Tools menu > Macro > Security"]
[null,null,null,null,null,null,null,null,"On the Security Level tab > Select Medium. Then select the Trusted Publishers tab and tick \"Trust access to Visual Basic Project\""]
[null,"This report will be minimised while processing and maximise when complete.\nIt will show all patients taking medication within customised time frame (shown in table below) and a column called \"TEST DONE\" will show a Y/N for those that have or have not had a test in the specified time frame. This filter is set to N by default, but may be changed. \nThe last test result is displayed for all drug groups.",null,null,null,null,null,null,"Click OK to close the Security window > Close Excel > Reopen this workbook and select \"Enable Macros\""]
[null,null,null,null,null,null,null,null," If dates show an error. Switch on the Analysis ToolPak via Tools menu > Addins"]
[]
[null,null,null,null,null,null,null,"Created: 13/07/2017"]
[null,null,null,null,null,null,null,"Version: 1.6"]
[null,"Search Criteria",null,null,null,null,null,"Written by: Bradley Sieve"]
[null,"Active Patients (Applied and Permanent)",null,"Issued in last",null,"Completed in last"]
[null,"Colour Code","Medication","MONTHS","Test","MONTHS",null,"Disclaimer"]
[null,"Group 1","Angiotensin-converting enzyme inhibitors",3,"Potassium",12,null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]
[null,null,"Angiotensin-11 receptor antagonists",null,"Potassium"]
[null,"Group 2","Aminosalicylates",4,"Haemoglobin",12]
[null,"Group 3","Contains the word: Levothyroxine",3,"TSH",14]
[null,"Group 4","Contains the word: Rivaroxaban",3,"Potassium",8]
[null,null,"Contains the word: Apixaban",null,"Potassium"]
[null,null,"Contains the word: Dabigatran",null,"Potassium"]
[null,null,"Contains the word: Edoxaban",null,"Potassium"]
[null,"Group 5","Drugs Affecting the Immune Response In Rheumatic Disease",3,"Haemoglobin",3]
[null,null,"Antimetabolites",null,"Haemoglobin"]
[null,"Group 6","Statins",3,"Cholesterol",12]
[]
[null,"Please feel free to change the months time frame in the table above"]
[]
[null,"Test Result Searches"]
[null,"Potassium","Latest read code in the potassium entity > 0"]
[null,"Haemoglobin","Latest read code in the haemoglobin entity > 0"]
[null,"TSH","Latest read code in the TSH entity > 0"]
[null,"Cholesterol","Latest read code in the Cholesterol entity > 0"]
[]
[null,"Drug Searches"]
[null,"Angiotensin-converting enzyme inhibitors",null,"BNF Code: 2050501"]
[null,"Angiotensin-11 receptor antagonists",null,"BNF Code: 2050502"]
[null,"Aminosalicylates",null,"BNF Code: 01050100"]
[null,"Levothyroxine",null,"Drug name: Levothyroxine%"]
[null,"Rivaroxaban",null,"Drug name: Rivaroxaban%"]
[null,"Apixaban",null,"Drug name: Apixaban%"]
[null,"Dabigatran",null,"Drug name: Dabigatran%"]
[null,"Edoxaban",null,"Drug name: Edoxaban%"]
[null,"Drugs Affecting the Immune Response In Rheumatic Disease",null,"BNF Code: 10010302"]
[null,"Antimetabolites",null,"BNF Code: 08010300"]
[null,"Statins",null,"BNF Code: 02120400"]